If playback doesn't begin shortly, try restarting your device.
1:09:27
5 seconds
Pull up for precise seeking
Data Exploration
1:09:39
•
You're signed out
Videos you watch may be added to the TV's watch history and influence TV recommendations. To avoid this, cancel and sign in to YouTube on your computer.
Take my Full MySQL Course Here: https://bit.ly/3tqOipr
Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project.…...more
Take my Full MySQL Course Here: https://bit.ly/3tqOipr
Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project.
Link to GitHub: https://bit.ly/3xNwzGK
Link to Dataset: https://ourworldindata.org/covid-deaths
** It appears the dataset may have been changed at the source. Please use these 2 links to get the data from the 2 excels:
1. Covid Deaths: https://github.com/AlexTheAnalyst/Por...
2. Covid Vaccinations: https://github.com/AlexTheAnalyst/Por...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvNPlease note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - https://www.patreon.com/AlexTheAnalyst
Alex The Analyst Shop - https://teespring.com/stores/alex-the...
____________________________________________
Websites:
GitHub: https://github.com/AlexTheAnalyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for0:00 Introduction
1:43 Getting Out Dataset
6:41 Importing Datasets into SQL
13:40 Data Exploration
1:13:35 Import Code into GitHub
I'm doing this in Oct 2021 and apparently one of the code chunks where you need to convert new_vaccinations column to integer, the sum value now has exceeded 2,147,483,647. So instead of converting it to "int", you will need to convert to "bigint". Hope this helps everyone.
Hi Alex! Doing this in July 2023 and I think the SMSS features have changed a bit. Instead of using SQL Server Native Client 11.0 it is now Microsoft OLE DB Provider for SQL Server. This took me a while to figure out and import. Hope this helps!
This was a lifesaver when I needed a portfolio quickly for a job interview while still being a beginner. It was easy to follow and I could base my own projects on it. This definitely was part of me getting the job!
To the ones stuck on 19:10 , use the following code to convert into float datatype when ''Null" Select location, date, total_cases,total_deaths,
(CONVERT(float, total_deaths) / NULLIF(CONVERT(float, total_cases), 0)) * 100 AS Deathpercentage
from PortfolioProject..covidDeaths
order by 1,2
Man... you're amazing. Don't congratulate us to have stayed until the end! It's TONS of work you've done and it's only to be applauded and appreciated! I bet many agree with me - against your sore throat you guided us through soooo many ideas and possibilities! Thank you so much and wish you MILLIONS views!
Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.
I’ve just started the video and I’m about 9 minutes in. I wanted to stop at this point to tell you I’m glad you showed your mistake live. It’s important for beginners to see that experts also make mistakes. It is encouraging. As a bonus, I will better remember to save as xlsx because you pointed it out. So thank you for leaving that in.
For those using Mac and found MySql as their preferred option; before you import data, be sure to reformat the date to yyyy-mm-dd so that MySql recognizes the date as an actual date. To do this, highlight the column and press control+1, go to date and select the format I mentioned above. Hope this helps someone!
I just completely watched this priceless video. Many thanks Alex for teaching us free of cost and guiding us all along. I am an Economist and have been learning data analysis since 2022 and it is amazing that I have found your channel and you.
I can’t express how much I appreciate you creating these tutorials. As a beginner prospective analyst looking to add projects to a portfolio, I was lost and overwhelmed. Your videos are a godsend. Thanks a lot
For whoever is having trouble in inserting their data in temp table, make sure to have the same data type of the columns in the covidDeaths table and temp table. And I found it better to specify the columns that you're inserting data in as:INSERT INTO #PercentageOfVaccinatedPopulation(location,date,population,new_vaccinations,TotalInLocation)
Alex, THANK YOU!!! I can't express my gratitude enough for everything you've done for us. I just made it through your SQL series (Beginner, Intermediate, & Advanced). Hooray! You make the process so simple and straightforward, which makes it SO easy to follow along. The project component is the BEST part. You're breaking down what we've learned and showing how we can actually use it. This is a HUGE missing link in today's education system. My Biomedical Engineering PhD program funding feel through (absolutely heartbreaking). I made it 2/3 of the way through and wrote 90 pages of a thesis that I was unable to use. While I was able to get a Master's degree, it was not in the subject/career I had wanted. My world was thrown upside down. I had no idea what I was going to do. Then, data analysis and YOU showed up in my life. You (and your "Become a Data Analyst" bootcamp) have served as a beacon of light and hope for my future. Bless you! And THANK YOU again!
Thank you so much Alex. I have been drilling myself to learn a lot regarding data analytics for 2 months and I'm trying to put all the things that I learned together. This is by far the best I found online. By the way, I have similar background as yours. I also work in healthcare and transitioning to data analytics due to PTSD during the pandemic and other work related injury. Regards from Vancouver, Canada :)
Alex, thank you so much for creating and sharing this video! It is a great help and an inspiration!I have a question about the temp table and views that were in it: is there a part two of this project where there's visualisation with this data? Or is this project considered complete?
Thank you, Alex! I am impressed with myself for completing this project, though, I am not 100% sure the reasoning behind everything we did, which means I still have a lot of work to do. This was amazing for getting my hands dirty and jumping right in to this exciting new world of SQL. I am looking forward to using this as a reference to make more of my own, customized projects.
For the query at 58:56, I was getting an error: "Arithmetic overflow error converting expression to data type int. Warning: Null value is eliminated by an aggregate or other SET operation."For those of you getting the same thing, change the "int" into "bigint", apparently its due to the sum function.
I did data analysis and error management in a HUGE database for sprint. The work I did was extremely similar to this. The database was way messier and more confusing than this, but if you can work out the problems as you go like he is, this is basically what I did everyday.
Firstly, thank you so much for all the resources you have. They are super helpful! I haven't finished this video yet but I'm following it along and it's really interesting since I'm doing the project now in 2023 and the dataset has changed a lot. I have a question though. I am at the point where you calculate % of vaccinations per population (1:06:10). If I do this calculation per country, I see that the US, for example, has a vaccination rate of over 200%. Would that indicate that the column new_vaccinations does not include unique vaccinations but also boosters? Thanks!
Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4
Alex The Analyst
Alex The Analyst
28KLikes
1,480,645Views
2021May 4
Take my Full MySQL Course Here: https://bit.ly/3tqOipr
Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project.
Link to GitHub: https://bit.ly/3xNwzGK
Link to Dataset: https://ourworldindata.org/covid-deaths
** It appears the dataset may have been changed at the source. Please use these 2 links to get the data from the 2 excels:
1. Covid Deaths: https://github.com/AlexTheAnalyst/Por...
2. Covid Vaccinations: https://github.com/AlexTheAnalyst/Por...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvNPlease note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - https://www.patreon.com/AlexTheAnalyst
Alex The Analyst Shop - https://teespring.com/stores/alex-the...
____________________________________________
Websites:
GitHub: https://github.com/AlexTheAnalyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for0:00 Introduction
1:43 Getting Out Dataset
6:41 Importing Datasets into SQL
13:40 Data Exploration
1:13:35 Import Code into GitHub